Academic Year/course:
2023/24
30250 - Databases II
Syllabus Information
Academic year:
2023/24
Subject:
30250 - Databases II
Faculty / School:
110 - Escuela de Ingeniería y Arquitectura
326 - Escuela Universitaria Politécnica de Teruel
Degree:
439 - Bachelor's Degree in Informatics Engineering
443 - Bachelor's Degree in Informatics Engineering
ECTS:
6.0
Year:
3
Semester:
Second semester
Subject type:
---
Module:
---
1. General information
The subject focuses on advanced aspects of databases, including their design, administration and management in distributed environments, developing the necessary skills for the design, creation and management of databases of medium size , as well as the choice of the appropriate technology. Given that databases are key in the information systems used by organizations to manage the information necessary for their operation, and also to address SDG challenges , it is considered that the acquisition of the learning results of the subject provides training and competence to the student to contribute to some extent to the achievement of the Sustainable Development Goals in a cross-cutting manner.
Recommendations to take the subject: to have taken "Databases" (fourth four-month period); it is convenient to have knowledge of object oriented programming.
2. Learning results
-
Be able to adequately design medium size databases and implement them in a commercial Database Management System.
-
Be able to select among different Database Management Systems, evaluating the advantages and disadvantages of each one for a given organization and information needs.
-
You are able to administer and operate a database: manage its users, set appropriate access permissions, optimize its operation, provide access programs, etc.
-
Be able to propose appropriate solutions for the implementation of database systems in a distributed environment.
3. Syllabus
1. Database Design:
-
Post-relational data models. Object-relational DBs.
-
Conceptual design, analysis of alternatives and their impact, practical examples.
2. Distributed Databases:
-
Motivation.
-
Architectures and design.
-
Integration and federation of different data sources.
-
Parallel BDs, BDs and Internet and mobile BDs.
3. Database Management Systems (DBMS):
-
Basic functions and architecture.
-
Main DBMSs and criteria for choosing a DBMS.
-
Advanced functionalities.
-
Examples (such as Oracle, PostgreSQL, NoSQL systems). Features, supported query language, other aspects (e.g., question optimization).
4. Administration and Exploitation of a Database:
-
Implementation and configuration of the main DBMSs.
-
Administrator roles.
-
Security and permissions management.
-
Other aspects of administration.
4. Academic activities
Lectures: sessions with the teachers in which the subject matter will be explained: 30 hours.
Problems and cases: sessions to solve practical cases presented by the teacher: 15 hours.
Laboratory practices: 15 hours.
Study of the subject; class preparation; practical activities: 84 hours.
Assessment tests. 6 hours.
Estimated hours for each type of activity are indicated.
5. Assessment system
Continuous assessment:
At EINA:
1. Practical computer work (internships): 30% of the final grade.
2. Practical work/projects: 20% of the final grade.
3. Written test with theoretical and practical assumptions: 50% of the final grade.
At EUPT:
1. Practical computer work (practices): 50% of the final grade.
2. Written test with theoretical and practical assumptions: 50% of the final grade.
Common to EINA and EUPT:
In the continuous assessment, the delivery of assignments and their presentations will be made throughout the development of the subject on the dates set by the teaching staff. The final grade will be obtained as the weighted average of the parts of which consists the assessment, taking into account that it is necessary to have at least 5.0 points out of 10.0 in each of them. In case of not reaching this minimum in any of the parts, the final grade will be the minimum between 4.0 and the result of weighting with the percentages of each part.
Final global test:
It will include the written test. In addition, students who have not submitted the practices and/or assignments regularly on the established partial due dates (or whose submissions are deficient) must submit said internships and/or assignments as part of the overall final exam, and must also pass an additional related test consisting of the resolution of a statement. The final grade is calculated as in the continuous assessmen